Step 1: Right click on table name, select rename and
rename table with “US School Shooting”
Step 2: Right click on US school shooting table.
Select Copy and paste US school shooting table. Go to the new table, select School
type column. Right click and select remove other columns, use the same process and
select remove duplicate.
Step 3: Go to add column and select add conditional
column. Give a name to the column (School Type Group) and then follow the GIF
and the screenshot to create the column. Click OK
Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK
Step 5: Rename the table with School type then select close and apply
Step 1: Right click on table name, select rename and rename table with “US School Shooting
Step 2: Right click on US school shooting table. Select Copy and paste US school shooting table. Go to the new table, select School type column. Right click and select remove other columns, use the same process and select remove duplicate.
Step 3: Go to add column and select add conditional column. Give a name to the column (School Type Group) and then follow the GIF and the screenshot to create the column. Click OK
Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK
Step 5: Rename the table with School type then select close and apply
https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Conditional column in power bi using power query
Step 1: Right click on table name, select rename and
rename table with “US School Shooting”
Step 2: Right click on US school shooting table.
Select Copy and paste US school shooting table. Go to the new table, select School
type column. Right click and select remove other columns, use the same process and
select remove duplicate.
Step 3: Go to add column and select add conditional
column. Give a name to the column (School Type Group) and then follow the GIF
and the screenshot to create the column. Click OK
Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK
Step 5: Rename the table with School type then select close and apply
Step 1: Right click on table name, select rename and rename table with “US School Shooting
Step 2: Right click on US school shooting table. Select Copy and paste US school shooting table. Go to the new table, select School type column. Right click and select remove other columns, use the same process and select remove duplicate.
Step 3: Go to add column and select add conditional column. Give a name to the column (School Type Group) and then follow the GIF and the screenshot to create the column. Click OK
Step 4: Go to add column, select conditional column. Provide name to the column (School type Order) and Follow the GIF and Screenshot to create the column. Click OK
Step 5: Rename the table with School type then select close and apply
https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Conditional column in power bi using power query